// clear
//
//
// use "asylum_openyears"
// keep cty_fips
// gen asylum=1
//
//
// append using "norm_openyears"
// keep cty_fips asylum
// gen normal=asylum==.
// replace asylum=0 if asylum==.
//
// rename cty_fips county




//collapse (sum) normal asylum, by(county)

clear
use "justnormasylum"
drop hasnormalorasylum
rename hasnormalschool normal
gen asylum=1-normal
rename cty_fips county
tempfile normal_asylum
save `normal_asylum'



import delimited "geocorr2000_22JUN1409473", rowr(3) clear


merge m:1 county using `normal_asylum', keep(2 3) nogen

keep state puma5 county afact2 normal
order state puma5 county afact2 normal
sort state puma5 county afact2 normal


save "puma_to_county_crosswalk", replace